Lets you manage connections to and modify external database tables. Not available unless a cell is selected.
Lets you connect to and use external database tables. Not available unless a cell is selected.
Lets you connect to and use external database tables.
Lets you customize database forms and name queries. Not available unless a form window is open.
Displays and deletes database forms. You can also rename a form. Not available unless a form window is open.
Displays and deletes database forms. You can also rename a form.
Creates and opens a form with which you can view a database table, browse through database records, enter criteria for searching, and add, delete, modify, or print records. Not available if you're typing in a cell.
Creates and opens a form with which you can view a database table, browse through database records, enter criteria for searching, and add, delete, modify, or print records.
Locates, extracts, modifies, adds, or deletes records in an internal or external database table. Not available unless a cell is selected.
Locates, extracts, modifies, adds, or deletes records in an internal or external database table.
Separates text entries in a single column into multiple columns containing text, numbers, dates, or times. Not available unless a cell is selected.
Separates text entries in a single column into multiple columns containing text, numbers, dates, or times.
Performs linear regression analysis. Not available unless a cell is selected.
Performs linear regression analysis.
Inverts or multiplies matrices. Not available unless a cell is selected.
Calculates a frequency distribution of the values to see how many of the values in a selected range fall within certain numeric intervals. Not available unless a cell is selected.
Calculates a frequency distribution of the values to see how many of the values in a selected range fall within certain numeric intervals.
Analyzes the results of formulas using one, two, or three variables. Not available unless a cell is selected.
Analyzes the results of formulas using one, two, or three variables.
Sorts rows of data in ascending or descending order. Not available unless a cell is selected.
Sorts rows of data in ascending or descending order.
Puts a sequence of values, dates, or times into selected cells. Not available unless a cell is selected.
Puts a sequence of values, dates, or times into selected cells.
Data menu
Use this menu to fill cells with numbers, dates, or times; sort data; perform what-if and regression analyses and matrix and distribution calculations; parse text entries; and work with internal and external database tables and forms.
